SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=12 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+sunday +grocery +ads' IN BOOLEAN MODE)) AND iCityID IN (4127,4233,4217,4251,4234,4131,4263,4236,4202,4145,4197,4253,4211,4168,4220,4204,4173,4261,4171,4138,4214,4277,4244,4186,4139,4175,4200,4248,4161,4149,4258,4219,4134,4135,4255,4267,4264,4206,4191,4157,4213,4151,4268,6816,4189,4235,4130,4275,4249,4176,4272,16257,4237,4216,4195,4205,4143,4241,4273,4240,4159,4163,4230,4222,4274,4265,4154,4164,4160,4198,4172,4266,4231,4177,4170,4137,4148,4179,4262,4187,4225,4196,4194,4254,16236,16235,4140,4174,4245,4224,4257,4229,4203,4167,4146,4221,4250,4215,4260,4144,4232,4188,4252,4129,4152,4183,4209,4247,4239,4256,4199,4270,4193,16244,9951,10043,4180,4208,4238,9893,4246,9958,4243,4136,16209,4166,4269,4185,4190,4169,4184,9840,4192,6817,4142,4279,10007,4132,4210,4156,4207,16211,4201,4278,4182,4155,4133,9960,4165,4218,4271,4147,9959,4162,10156,4181,4276,4280,6815,4128,4227,4212,4158,4150,4223,9834,9952,4259,4898,10069,10033,4858,9870,4897,9858,9819,10074) ORDER BY FIELD(iCityID, 4127,4233,4217,4251,4234,4131,4263,4236,4202,4145,4197,4253,4211,4168,4220,4204,4173,4261,4171,4138,4214,4277,4244,4186,4139,4175,4200,4248,4161,4149,4258,4219,4134,4135,4255,4267,4264,4206,4191,4157,4213,4151,4268,6816,4189,4235,4130,4275,4249,4176,4272,16257,4237,4216,4195,4205,4143,4241,4273,4240,4159,4163,4230,4222,4274,4265,4154,4164,4160,4198,4172,4266,4231,4177,4170,4137,4148,4179,4262,4187,4225,4196,4194,4254,16236,16235,4140,4174,4245,4224,4257,4229,4203,4167,4146,4221,4250,4215,4260,4144,4232,4188,4252,4129,4152,4183,4209,4247,4239,4256,4199,4270,4193,16244,9951,10043,4180,4208,4238,9893,4246,9958,4243,4136,16209,4166,4269,4185,4190,4169,4184,9840,4192,6817,4142,4279,10007,4132,4210,4156,4207,16211,4201,4278,4182,4155,4133,9960,4165,4218,4271,4147,9959,4162,10156,4181,4276,4280,6815,4128,4227,4212,4158,4150,4223,9834,9952,4259,4898,10069,10033,4858,9870,4897,9858,9819,10074) ASC, p.tmPosted DESC LIMIT 24
sunday grocery ads, Community Classifieds, Local Events, Friends, Activities in Absecon
